[dbo].[BAEValidateLogin]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEValidateLogin
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@pUsername
varchar(60)
60
@pPassword
varchar(100)
100
SQL Script
create
procedure
[dbo]
.
[BAEValidateLogin]
@pUsername
as
varchar
(
60
),
@pPassword
AS
varchar
(
100
)
AS
SELECT
*
FROM
Name_Security
WHERE
WEB_LOGIN
=
@pUsername
AND
[PASSWORD]
=
@pPassword
;
GO
Uses
[dbo].[Name_Security]
dbo